File manager - Edit - /home/autoph/public_html/weCare/Covid19/ContactTracing/COVIDAPP/save_QR_CODE.php
Back
<?php date_default_timezone_set('Asia/Manila'); header('Content-Type: application/json'); $sqlUser = 'autoph_arnel'; $sqlDatabase = 'autoph_covid19db'; $sqlPass = 'Hke@2001'; $toDate = date_create() ->format("m/d/Y"); // for viewing date only $toTime = date("h:i a"); $myDate ="As of ".$toDate; $myDateTime = $toDate . " | ". $toTime; $conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) or die ("Couldn't connct to MySQL server on $sqlHost: ". mysql_error(). '.'); $db = mysql_select_db($sqlDatabase, $conn) or die ("Couldn't select database $sqlDatabase: ". mysql_error(). '.'); $empID= $_REQUEST['empID']; $qrKey = $_REQUEST['qrKey']; $qrData = $_REQUEST['qrData']; //====================================================================== if($qrKey == 10102424){ $exItem = explode(":",$qrData); $empIDXX = $exItem[0]; $empName = $exItem[1]; $empDept = $exItem[2]; $sql = "INSERT INTO app_contact_tracing_db (id, emp_name, qr_data, emp_id, emp_dept, scan_by, scanDateTime) VALUES('','$empName','$qrData','$empIDXX', '$empDept','$empID','$myDateTime')"; $sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); $msg ="Scan Complete"; $json = json_encode(["Status"=>$msg]); } //====================================================================== if($qrKey == 1024400){ $return_dir = Array(); $sql = "SELECT * FROM app_contact_tracing_db WHERE `status` ='1' AND `scan_by`='$empID' ORDER BY `id` DESC"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_dir[]= $sqlRecord; } $json = json_encode($return_dir); } if($did_something === 0) { $msg = did_nothing_message; $json = json_encode(["status" => "$MyCustomerID", "statusCode" => "$customerType"]); } echo $json; ?>
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings